Seward County Community College/Area Technical School
Course Syllabus
- TITLE OF COURSE: BT1033 - Microcomputer Database Management
- COURSE DESCRIPTION: 3 Credit Hour Lecture Course
This course is designed to acquaint the student with a software system for managing the storage and collection of data used and produced by a microcomputer. For each unit of
credit, a minimum of three hours per week with one of the hours for class and
two hours for studying/preparation outside of class is expected.
- DIVISION/DEPT/PROGRAM MISSION STATEMENT:
The CIS Program will provide superior learning opportunities in the area of information technology, utilizing state-of-the-art technology, for both CIS majors and non CIS majors to enable all students to achieve their career and/or educational goals.
- TEXTBOOK AND MATERIALS:
- Go! With Microsoft Access 2007 Comprehensive, Gaskin; Pearson, Prentice Hall.
- Storage Media (flash drives are recommended)
- SCCC OUTCOMES: Students who successfully complete this course will demonstrate the ability to do the following SCCC Outcomes:
- Outcome #1 – Read with comprehension, be critical of what they read, and apply knowledge gained to real life situations
- Outcome # 5 – Demonstrate the ability to think critically by gathering facts, generating insights, analyzing data, and evaluating information
- Outcome # 6 - Utilize current technology relevant to their respective disciplines
- Outcome #9 – Exhibit workplace skills that include respect for others, teamwork competence, attendance/punctuality, decision making, conflict resolution, truthfulness/honesty, positive attitude, judgment, and responsibility
- GENERAL COURSE OUTCOMES/COMPETENCIES: Upon completion of the Microcomputer Database Management course with 80% or higher mastery the student should be able to:
- Perform basic database management activities using database software
- Utilize advanced functions of database management software for creation of forms, tables, queries and reports
- TOPICAL COURSE OUTLINE:
- Getting Started with Access 2002
- Using Tables and Queries
- Using Forms
- Using Reports
- Modifying a Database Structure
- Creating Multiple Table Queries
- Developing Forms and Subforms
- Sharing Information and Improving Reports
- Sharing Access Information with Other Office Programs
- Creating Data Access Pages
- Creating Advanced Queries
- Creating Advanced Forms and Reports
- Managing Database Objects
- Creating Macros
- Creating Modules
- Managing the Database
- INSTRUCTIONAL METHODS:
- Classroom Lecture
- Classroom Discussion
- Hands-on computer lab projects and database assignments
- Instructors will enforce the Academic Honor Code & Cheating Policy as set forth in the SCCC College Catalog. Students who fail to adhere to this policy will receive an F for the course final grade unless otherwise stated in the instructors's course policies.
- INSTRUCTIONAL AND RESOURCE MATERIALS:
- Prenhall.com Student Data Files
- Additional materials available at www.prenhall.com
- METHODS OF ASSESSMENT:
- Outcomes #1, 5, 6, and 9 will be assessed by the following:
- Hands-on and written examinations
- Hands-on tutorials and lab assignments
- Development of portfolio project
- ADA STATEMENT
- If you believe that you are entitled to special accommodations under the Americans with Disabilities Act, please contact the Dean of Student Services at 620-417-1016 or visit the office located in the Hobble Academic Building.
(Revised 11/10)